*** Copy thy neighbour: Spatial interdependences in the democracy-repression nexus ***
*** Journal of Human Rights ***
*** Created by Roman-Gabriel Olar on 01/05/2019 ***
*** Last modified on 25/08/2023 ***

*** Section A6 Online Appendix - Summary Statistics by region ***

*** Mean ***
use "MainData.dta", clear
collapse (mean) theta_mean l_polyarchy l_gdp_gro l_lngdppc l_lnpop civil_war international_war l_resdep, by(e_regionpol)
export excel using "C:\Users\Administrator\Dropbox\Papers\Spatial repression and democracy\Data\Tables\mean_region.xls", firstrow(variables)

*** Median ***
use "MainData.dta", clear
collapse (median) theta_mean l_polyarchy l_gdp_gro l_lngdppc l_lnpop civil_war international_war l_resdep, by(e_regionpol)
export excel using "C:\Users\Administrator\Dropbox\Papers\Spatial repression and democracy\Data\Tables\median_region.xls", firstrow(variables)

*** Standard deviation ***
use "MainData.dta", clear
collapse (sd) theta_mean l_polyarchy l_gdp_gro l_lngdppc l_lnpop civil_war international_war l_resdep, by(e_regionpol)
export excel using "C:\Users\Administrator\Dropbox\Papers\Spatial repression and democracy\Data\Tables\sd_region.xls", firstrow(variables)
